Define Pension Plan
OBJECTIVE
The Define Pension Plan function is used to manage RPP, RRSP, DPSP, group RRSP and Labour funds (LF) deductions.
|
Before creating a pension plan, refer to the How-to Create a pension plan in maestro* document to learn about the impacts of each pension plan. |
Steps
|
maestro* > Time Management > Maintenance > Payroll > Define Pension Plan |
Create a pension plan
- Enter the required information in the Main Fields tab:
The Configuration icon is used to define entry options for the Code field.
Field
Description
Code
Pension plan code.
Description
French description of the fund.
English Desc.
English description of the fund.
On stub
French description to be printed on the pay slip.
English stub
English description to be printed on the pay slip.
Type
Fund type.
Available values:
Number
Permit number of the fund.
- Select a management method from the three methods below:
Field
Description
Flat Rate
Employee/Employer
Gross amount used to calculate the pension plan.
Hourly amount
Employee/Employer
Hourly amount used to calculate the pension plan.
% Gross Earning
Employee/Employer
Percentage of the gross salary used to calculate the pension plan.
- Select a maximum type from the two types below:
The maximum is the maximum applicable for all employees affected by the pension plan.
The maximum entered in Employee Management supersedes this value.
Field
Description
Weekly maximum
Maximum accumulated weekly.
Annual Maximum
Maximum accumulated annually.
- Complete the other fields based on requirements:
Field
Description
No govern. plan
Used if the maximum RRQ and CPP (federal pension plan) has been reached or the RRP and CPP amounts calculated equal 0 on Payroll Calculation.
Reference formula
Used to specify the variable for the amount used to calculate the pension plan.
NOTES: If no formula is specified, the system uses the SALFP variable by default.
View the appendix for all available variables and how to use them.
Fed Credit Factor
Employee/Employer
Federal income tax credit factor
NOTE: 1.000 = 100%
Prov Credit Factor
Employee/Employer
Provincial income tax credit factor
NOTE: 1.000 = 100%
Fed Income Tax Credit %
Federal income tax credit percentage.
NOTES: This is a factor. It is divided by 100 for the calculation.
This percentage applies only to pension plans managed by unions.
Prov Income Tax Credit %
Provincial income tax credit percentage.
NOTES: This is a factor. It is divided by 100 for the calculation.
This percentage applies only to pension plans managed by unions.
Fringe Benefit Account
The Fringe Benefit account is an accrued fringe benefits account if the hour transfer is set to Balanced. However, if the hour transfer is defined as Normal, an expense account must be entered in the Fringe Benefit Account field.
Remittance Account
The remittance account is a liability account used to track pension plan deductions.
- Click Save.
See also
APPENDIX
Variables available to determine the calculation for the Pension Plan
|
The Define Earning/Deduction Codes function has a direct impact on formulas that calculate the pension plan. You must correctly configure the bonus in the Payroll Calculation tab. The table below explains how the bonuses must be configured to ensure that the variables use them. |
|
Variable |
Source of the calculation to determine the pension fund |
Sectors |
Define Earning/Deduction Codes - Payroll Calculation tab |
|||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
Federal Income Tax |
Provincial Income Tax |
Pension Fund |
Committee Calculation |
Union |
QPP |
W/C - CSST |
Group Insurance |
|
SALFP |
Paid hours (regular, half, double and vacation) + Taxable vacation pay + all types of bonuses for which the Pension Fund box is checked. NOTE: The amount of Taxable vacation pay comes from the Hours Management in the Taxable VacPay field. |
All |
|
|
X |
|
|
|
|
|
|
SBFED |
Paid hours (regular, half, double and vacation) vacation pay + all types of bonuses for which the Federal Income Tax box is checked. |
All |
X |
|
|
|
|
|
|
|
|
SBPRO |
Paid hours (regular, half, double and vacation) + vacation pay + all types of bonuses for which the Provincial Income Tax box is checked. |
All |
|
X |
|
|
|
|
|
|
|
SALCOMITE |
Paid hours (regular, half, double) + paid vacation + all types of bonuses for which the Provincial Income Tax box is checked. |
All |
|
|
|
X |
|
|
|
|
|
HRPAYE or HRPAID |
Paid hours (regular, half, double) + all types of bonuses for which the Committee Calculation in Hours box is checked. NOTES: Income bonuses are calculated based on regular time. Paid vacation days are not included in this variable. |
All |
|
|
|
|
|
|
|
|
|
HRTRAV or HRWORKED |
Hours worked + all types of bonuses for which the Committee Calculation in Hours box is checked. |
All |
|
|
|
|
|
|
|
|
|
VACCALCULE |
Vacation amount calculated only. |
All |
|
|
|
|
|
|
|
|
|
SALREG |
Hours paid at regular time + all types of bonuses at regular time. |
All |
|
|
|
|
|
|
|
|
|
SALOVER |
Hours paid at time-and-a-half + all types of bonuses paid at time-and-a-half. |
|
|
|
|
|
|
|
|
|
|
SALDOUBLE |
Hours paid at double time + all types of bonuses paid at double time. |
|
|
|
|
|
|
|
|
|
|
SALFP0 |
Paid hours (regular, half, double and vacation) + Taxable vacation pay + all types of bonuses for which the Pension Fund box is checked. NOTE: The amount of Taxable vacation pay comes from the Hours Management in the Taxable VacPay field. |
0 |
|
|
X |
|
|
|
|
|
|
SALREG0 |
Hours paid at regular time + all types of bonuses at regular time for sector 0. |
0 |
|
|
|
|
|
|
|
|
|
SALOVER0 |
Hours paid at time-and-a-half + all types of bonuses paid at time-and-a-half for sector 0. |
0 |
|
|
|
|
|
|
|
|
|
SALDOUBLE0 |
Hours paid at double time + all types of bonuses paid at double time for sector 0. |
0 |
|
|
|
|
|
|
|
|
|
SALREGRAT |
Worked Hours time * regular hourly rate. NOTE : Does not include premium and bonus, only worked hours. |
All |
|
|
|
|
|
|
|
|
|
SALREGRAT0 |
Worked Hours time * regular hourly rate for sector 0. NOTE : Does not include premium and bonus, only worked hours. |
0 |
|
|
|
|
|
|
|
|
|
HRPAYE0 or HRPAID0 |
Paid hours (regular, half, double) + all types of bonuses for which the Committee Calculation in Hours box is checked for sector 0. NOTES: Income bonuses are calculated based on regular time. Paid vacation days are not included in this variable. |
0 |
|
|
|
|
|
|
|
|
|
HRTRAV0 or HRWORKED0 |
Paid hours (regular, half, double) + all types of bonuses for which the Committee Calculation in Hours box is checked for sector 0. NOTES: Income bonuses are calculated based on regular time. Paid vacation days are not included. |
0 |
|
|
|
|
|
|
|
|
|
SALTOTEMP |
Paid hours (regular, half, double) + all types of bonuses for sector 0 for which the Committee Calculation in Salary box is checked. |
0 |
|
|
|
X |
|
|
|
|
|
SALSYNDICAT |
Paid hours (regular, half, double) + paid vacation + all types of bonuses for which the Affect the union calculations in salary box is checked. |
Based on Config. |
|
|
|
|
X |
|
|
|
|
VACIMP |
Amount of taxable vacation paid comes from Hours Management. NOTE: This amount can be entered manually in Hours Management, Taxable VacPay field or automatically if you use a bonuses type Vacation. |
|
|
|
|
|
|
|
|
|
|
PRIME.premium code |
Premium/bonus amount. |
All |
|
|
|
|
|
|
|
|
|
TAUXVAC |
Vacation rate for sector 0. |
0 |
|
|
|
|
|
|
|
|
|
TAUXVCONST |
Vacation rate for sectors 1 to 5. |
1 to 5 |
|
|
|
|
|
|
|
|
|
TH1 |
Default hourly rate. |
All |
|
|
|
|
|
|
|
|
|
SALHEURE |
Paid hours (regular, half, double) + revenue premiums/bonuses. |
All |
|
|
|
|
|
|
|
|
|
SALHREEMP |
Paid hours (regular, half, double) in sector 0 + revenue premiums/bonuses in sector 0. |
0 |
|
|
|
|
|
|
|
|
|
SALFERIE |
Number of hours for statutory holidays entered in Hours Management * employee's default hourly rate. |
All |
|
|
|
|
|
|
|
|
|
MAXASS |
Paid hours (regular, half, double, and stat holiday) + paid vacation + all types of premiums/bonuses for which the Calculate Employment Insurance on Salary box is checked + employer part of the pension plan is set to type 2-RRSP. |
|
|
|
|
|
|
|
|
X |
|
MAXASSRED |
Same content as MAXASS, but for values entered with sector 0 for an employee who's Use the Reduced Rate box is checked. |
0 |
|
|
|
|
|
|
|
X |
|
MAXCSST |
Paid hours (regular, half, double, and stat holiday) + paid vacation + all premiums/bonuses for which the Affects W/C - CSST Ded. box is checked. |
All |
|
|
|
|
|
|
X |
|
|
ADMRRQ |
Paid hours (regular, half, double and stat holiday) + paid vacation + all premiums/bonuses for which the Affects CPP/QPP box is checked + the employer's part of the pension plan is types 2-RRSP and 4-group RRSP + taxable benefits. |
All |
|
|
|
|
|
X |
|
|
|
TAUXFSS |
Healthcare deduction rate. |
All |
|
|
|
|
|
|
|
|
|
MNTFSS |
SBPRO * TAUXFSS |
|
|
|
|
|
|
|
|
|
|
TAUXCSST |
W/C - CSST rate entered in the work category. |
|
|
|
|
|
|
|
X |
|
|
SALHRECONS |
Paid hours (regular, half, double) + revenue premiums/bonuses for amounts entered for sectors 1 to 5. |
1 to 5 |
|
|
|
|
|
|
|
|
|
SALTOTCONST |
Paid hours (regular, half, double) + paid vacation + all premiums/bonuses for which the Affects Committee Calculations for Earnings box is checked for values entered for sectors 1 to 5. |
1 to 5 |
|
|
|
X |
|
|
|
|
|
MNTVACCONST |
TAUXVCONST / 100 * SALTOTCONST |
|
|
|
|
|
|
|
|
|